<?php

use Illuminate\Database\Seeder;

class SortTableSeeder extends Seeder
{
    /**
     * Run the database seeds.
     *
     * @return void
     */
    public function run()
    {
        DB::table('sort')->insert([

            //根分类
            ['sname' => '男鞋', 'pid' => 0, 'path' => '0,', 'descr' => '根类别 男鞋', 'state' => 1, 'created_at' => date('Y-m-d H:i:s'), 'updated_at' => date('Y-m-d H:i:s') ],   //id=1
            ['sname' => '女鞋', 'pid' => 0, 'path' => '0,', 'descr' => '根类别 女鞋', 'state' => 1, 'created_at' => date('Y-m-d H:i:s'), 'updated_at' => date('Y-m-d H:i:s') ],   //id=2
            ['sname' => '童鞋', 'pid' => 0, 'path' => '0,', 'descr' => '根类别 童鞋', 'state' => 1, 'created_at' => date('Y-m-d H:i:s'), 'updated_at' => date('Y-m-d H:i:s') ],   //id=3

            //男鞋的子分类
            ['sname' => '休闲鞋', 'pid' => 1, 'path' => '0,1,', 'descr' => '男鞋 休闲鞋', 'state' => 1, 'created_at' => date('Y-m-d H:i:s'), 'updated_at' => date('Y-m-d H:i:s') ],    //id=4
            ['sname' => '足球鞋', 'pid' => 1, 'path' => '0,1,', 'descr' => '男鞋 足球鞋', 'state' => 1, 'created_at' => date('Y-m-d H:i:s'), 'updated_at' => date('Y-m-d H:i:s') ],    //id=5
            ['sname' => '篮球鞋', 'pid' => 1, 'path' => '0,1,', 'descr' => '男鞋 篮球鞋', 'state' => 1, 'created_at' => date('Y-m-d H:i:s'), 'updated_at' => date('Y-m-d H:i:s') ],    //id=6
            ['sname' => '板鞋', 'pid' => 1, 'path' => '0,1,', 'descr' => '男鞋 板鞋', 'state' => 1, 'created_at' => date('Y-m-d H:i:s'), 'updated_at' => date('Y-m-d H:i:s') ],    //id=7
            ['sname' => '跑步鞋', 'pid' => 1, 'path' => '0,1,', 'descr' => '男鞋 跑步鞋', 'state' => 1, 'created_at' => date('Y-m-d H:i:s'), 'updated_at' => date('Y-m-d H:i:s') ],    //id=8
            ['sname' => '帆布鞋', 'pid' => 1, 'path' => '0,1,', 'descr' => '男鞋 帆布鞋', 'state' => 1, 'created_at' => date('Y-m-d H:i:s'), 'updated_at' => date('Y-m-d H:i:s') ],    //id=9

            //女鞋的子分类
            ['sname' => '休闲鞋', 'pid' => 2, 'path' => '0,2,', 'descr' => '女鞋 休闲鞋', 'state' => 1, 'created_at' => date('Y-m-d H:i:s'), 'updated_at' => date('Y-m-d H:i:s') ],    //id=10
            ['sname' => '跑步鞋', 'pid' => 2, 'path' => '0,2,', 'descr' => '女鞋 跑步鞋', 'state' => 1, 'created_at' => date('Y-m-d H:i:s'), 'updated_at' => date('Y-m-d H:i:s') ],    //id=11
            ['sname' => '板鞋', 'pid' => 2, 'path' => '0,2,', 'descr' => '女鞋 板鞋', 'state' => 1, 'created_at' => date('Y-m-d H:i:s'), 'updated_at' => date('Y-m-d H:i:s') ],    //id=12
            ['sname' => '帆布鞋', 'pid' => 2, 'path' => '0,2,', 'descr' => '女鞋 帆布鞋', 'state' => 1, 'created_at' => date('Y-m-d H:i:s'), 'updated_at' => date('Y-m-d H:i:s') ],    //id=13
            ['sname' => '网球鞋', 'pid' => 2, 'path' => '0,2,', 'descr' => '女鞋 网球鞋', 'state' => 1, 'created_at' => date('Y-m-d H:i:s'), 'updated_at' => date('Y-m-d H:i:s') ],    //id=14
            ['sname' => '拖鞋', 'pid' => 2, 'path' => '0,2,', 'descr' => '女鞋 拖鞋', 'state' => 1, 'created_at' => date('Y-m-d H:i:s'), 'updated_at' => date('Y-m-d H:i:s') ],    //id=15

            //童鞋的子分类
            ['sname' => '男童鞋', 'pid' => 3, 'path' => '0,3,', 'descr' => '童鞋 男童鞋', 'state' => 1, 'created_at' => date('Y-m-d H:i:s'), 'updated_at' => date('Y-m-d H:i:s') ],    //id=16
            ['sname' => '女童鞋', 'pid' => 3, 'path' => '0,3,', 'descr' => '童鞋 女童鞋', 'state' => 1, 'created_at' => date('Y-m-d H:i:s'), 'updated_at' => date('Y-m-d H:i:s') ],    //id=17

            //男童鞋的子分类
            ['sname' => '婴童(0-4岁)', 'pid' => 16, 'path' => '0,3,16,', 'descr' => '童鞋 男童鞋 婴童', 'state' => 1, 'created_at' => date('Y-m-d H:i:s'), 'updated_at' => date('Y-m-d H:i:s') ],    //id=18
            ['sname' => '小童(4-10岁)', 'pid' => 16, 'path' => '0,3,16,', 'descr' => '童鞋 男童鞋 小童', 'state' => 1, 'created_at' => date('Y-m-d H:i:s'), 'updated_at' => date('Y-m-d H:i:s') ],    //id=19
            ['sname' => '大童(10-13岁)', 'pid' => 16, 'path' => '0,3,16,', 'descr' => '童鞋 男童鞋 大童', 'state' => 1, 'created_at' => date('Y-m-d H:i:s'), 'updated_at' => date('Y-m-d H:i:s') ],    //id=20

            //女童鞋的子分类
            ['sname' => '婴童(0-4岁)', 'pid' => 17, 'path' => '0,3,17,', 'descr' => '童鞋 女童鞋 婴童', 'state' => 1, 'created_at' => date('Y-m-d H:i:s'), 'updated_at' => date('Y-m-d H:i:s') ],    //id=21
            ['sname' => '小童(4-10岁)', 'pid' => 17, 'path' => '0,3,17,', 'descr' => '童鞋 女童鞋 小童', 'state' => 1, 'created_at' => date('Y-m-d H:i:s'), 'updated_at' => date('Y-m-d H:i:s') ],    //id=22
            ['sname' => '大童(10-13岁)', 'pid' => 17, 'path' => '0,3,17,', 'descr' => '童鞋 女童鞋 大童', 'state' => 1, 'created_at' => date('Y-m-d H:i:s'), 'updated_at' => date('Y-m-d H:i:s') ],    //id=23

        ]);
    }
}
